import pandas as pd

# 创建数据
data = {
    "主商家编码": ["5DT51787-HB"] * 6,
    "规格商家编码": [
        "5DT517874604DJ2",
        "5DT517874605DJ2",
        "5DT517874606DJ2",
        "5DT517874607DJ2",
        "5DT517874608DJ2",
        "5DT517874609DJ2",
    ],
    "商品名称": ["两件装-童装短袖T恤"] * 6,
    "颜色及规格": ["混合色;4Y", "混合色;5Y", "混合色;6Y", "混合色;7Y", "混合色;8Y", "混合色;9Y"],
    "颜色属性": ["混合色"] * 6,
    "第二属性": ["4Y", "5Y", "6Y", "7Y", "8Y", "9Y"],
}

# 创建 DataFrame
df = pd.DataFrame(data)

# 保存到 Excel 文件
df.to_excel("product_data.xlsx", index=False)

print("Excel 文件已生成：product_data.xlsx")
